Example of using SQL*Plus

Basic Oracle SQL query statements

SQL> select DEPARTMENT_ID, DEPARTMENT_NAME from DEPARTMENTS where LOCATION_ID = 1700;

DEPARTMENT_ID DEPARTMENT_NAME
----------------------------------------------------------------
           10 Administration
           90 Executive
          100 Finance
          110 Accounting
          120 Treasury
          270 Payroll

6 rows selected.

SQL>